The Multi-Entity Control application has been developed to automatically post a balancing entry to the G/L Entry table when the source entry has an imbalance across multiple dimension values. For example, if the Global Dimension 1 code is set as an Entity Code and entries are posted into the Business Central General Ledger with more than one entity value, The Multi-Entity Control application will be triggered by the posting process and will check to make sure the entry balances by each Entity code. If an imbalance is identified, a system generated entry will be created.

The application has the ability to balance by Global Dimension 1 and/or Global Dimension 2 code and a predetermined balancing account is defined which is used during the automatic posting process.

The General Ledger Setup includes new fields to facilitate our application:

The Balance By field is used to identify the dimension that is used for the automatic balancing.
The Journal Template field is used to select a journal that will be used to post the multi entity postings in the intercompany accounts between different entities.
The Journal Batch Name is the journal batch that will be used for the intercompany entries.
The Account No. is the intercompany account that will be used to post the intercompany entries.
The Define Dimension Values on Balancing Entry field allows you to preset the values for the other dimension codes on the balancing entry.

This application has been developed for the specific business purpose/need to maintain a balanced ledger by a fund, entity or a different type of dimension. With minimal setup, and simple, intuitive changes to the Business Central user Interface this application is easy to use and maintain.

Multi-Entity Control

by Apptitude Solutions, Inc.